Tabela ArchiveDoc

Definicja tabeli ArchiveDoc

Name

ArchiveDoc

Code

ArchiveDoc

Comment

 


Lista kolumn tabeli ArchiveDoc

Name

Code

ArchiveDocID

ArchiveDocID

Arc_ArchiveDocID

Arc_ArchiveDocID

ArchiveDocTypeID

ArchiveDocTypeID

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

EpisodeID

EpisodeID

ArchiveDocStateID

ArchiveDocStateID

ArchiveID

ArchiveID

PersonID

PersonID

ArchiveDocStorageTimeID

ArchiveDocStorageTimeID

ArchiveDocLocID

ArchiveDocLocID

Active

Active

PrefixID

PrefixID

ArchiveDocNo

ArchiveDocNo

StartDT

StartDT

StopDT

StopDT

Historical

Historical

Comments

Comments

InsertingPerson

InsertingPerson

InsertDT

InsertDT

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT

ProviderPersonID

ProviderPersonID

OriginalArchiveDocID

OriginalArchiveDocID

SuffixID

SuffixID

CreateLocID

CreateLocID

SourceDocuments

SourceDocuments

ArchiveCategoryID

ArchiveCategoryID

CreateDT

CreateDT


Kolumna ArchiveDocID tabeli ArchiveDoc

Definicja kolumny ArchiveDocID tabeli ArchiveDoc

Name

ArchiveDocID

Code

ArchiveDocID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Arc_ArchiveDocID tabeli ArchiveDoc

Definicja kolumny Arc_ArchiveDocID tabeli ArchiveDoc

Name

Arc_ArchiveDocID

Code

Arc_ArchiveDocID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ArchiveDocTypeID tabeli ArchiveDoc

Definicja kolumny ArchiveDocTypeID tabeli ArchiveDoc

Name

ArchiveDocTypeID

Code

ArchiveDocTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna IdentifierTypeID tabeli ArchiveDoc

Definicja kolumny IdentifierTypeID tabeli ArchiveDoc

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalValue tabeli ArchiveDoc

Definicja kolumny ExternalValue tabeli ArchiveDoc

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli ArchiveDoc

Definicja kolumny EpisodeID tabeli ArchiveDoc

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ArchiveDocStateID tabeli ArchiveDoc

Definicja kolumny ArchiveDocStateID tabeli ArchiveDoc

Name

ArchiveDocStateID

Code

ArchiveDocStateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ArchiveID tabeli ArchiveDoc

Definicja kolumny ArchiveID tabeli ArchiveDoc

Name

ArchiveID

Code

ArchiveID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli ArchiveDoc

Definicja kolumny PersonID tabeli ArchiveDoc

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ArchiveDocStorageTimeID tabeli ArchiveDoc

Definicja kolumny ArchiveDocStorageTimeID tabeli ArchiveDoc

Name

ArchiveDocStorageTimeID

Code

ArchiveDocStorageTimeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ArchiveDocLocID tabeli ArchiveDoc

Definicja kolumny ArchiveDocLocID tabeli ArchiveDoc

Name

ArchiveDocLocID

Code

ArchiveDocLocID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID lokalizacji dokumentacji


Kolumna Active tabeli ArchiveDoc

Definicja kolumny Active tabeli ArchiveDoc

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna PrefixID tabeli ArchiveDoc

Definicja kolumny PrefixID tabeli ArchiveDoc

Name

PrefixID

Code

PrefixID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ArchiveDocNo tabeli ArchiveDoc

Definicja kolumny ArchiveDocNo tabeli ArchiveDoc

Name

ArchiveDocNo

Code

ArchiveDocNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ArchiveDoc

Definicja kolumny StartDT tabeli ArchiveDoc

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ArchiveDoc

Definicja kolumny StopDT tabeli ArchiveDoc

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Historical tabeli ArchiveDoc

Definicja kolumny Historical tabeli ArchiveDoc

Name

Historical

Code

Historical

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Comments tabeli ArchiveDoc

Definicja kolumny Comments tabeli ArchiveDoc

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli ArchiveDoc

Definicja kolumny InsertingPerson tabeli ArchiveDoc

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertDT tabeli ArchiveDoc

Definicja kolumny InsertDT tabeli ArchiveDoc

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna LastModifiedPerson tabeli ArchiveDoc

Definicja kolumny LastModifiedPerson tabeli ArchiveDoc

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli ArchiveDoc

Definicja kolumny LastModifiedDT tabeli ArchiveDoc

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ProviderPersonID tabeli ArchiveDoc

Definicja kolumny ProviderPersonID tabeli ArchiveDoc

Name

ProviderPersonID

Code

ProviderPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OriginalArchiveDocID tabeli ArchiveDoc

Definicja kolumny OriginalArchiveDocID tabeli ArchiveDoc

Name

OriginalArchiveDocID

Code

OriginalArchiveDocID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID oryginalnej dokumentacji


Kolumna SuffixID tabeli ArchiveDoc

Definicja kolumny SuffixID tabeli ArchiveDoc

Name

SuffixID

Code

SuffixID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID elementu wykorzystywanego jako prefix dla numeru dokumentacji


Kolumna CreateLocID tabeli ArchiveDoc

Definicja kolumny CreateLocID tabeli ArchiveDoc

Name

CreateLocID

Code

CreateLocID

Data Type

NUMBER(10)

Mandatory

No

Comment

Miejsce utworzenia dokumentacji


Kolumna SourceDocuments tabeli ArchiveDoc

Definicja kolumny SourceDocuments tabeli ArchiveDoc

Name

SourceDocuments

Code

SourceDocuments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Lista dokumentów zródlowych znajdujaca sie w danym woluminie


Kolumna ArchiveCategoryID tabeli ArchiveDoc

Definicja kolumny ArchiveCategoryID tabeli ArchiveDoc

Name

ArchiveCategoryID

Code

ArchiveCategoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

Wartosc oznacza kategorie archiwalna dokumentacji ustawiana podczas przeniesienia do archiwum


Kolumna CreateDT tabeli ArchiveDoc

Definicja kolumny CreateDT tabeli ArchiveDoc

Name

CreateDT

Code

CreateDT

Data Type

DATE

Mandatory

No

Comment

Data utworzenia dokumentacji


Lista kluczy tabeli ArchiveDoc

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ArchiveDoc

Definicja klucza Identifier_1 tabeli ArchiveDoc

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment